package com.ecoolex.discount.sales.entity;

import com.ecoolex.framework.common.annotation.Description;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import org.springframework.lang.NonNull;

public class DiscountProductExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected Integer offset;

    protected Integer rows;

    public DiscountProductExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public DiscountProductExample orderBy(String orderByClause) {
        this.setOrderByClause(orderByClause);
        return this;
    }

    public DiscountProductExample orderBy(String ... orderByClauses) {
        StringBuffer sb = new StringBuffer();
        for (int i = 0; i < orderByClauses.length; i++) {
            sb.append(orderByClauses[i]);
            if (i < orderByClauses.length - 1) {
                sb.append(" , ");
            }
        }
        this.setOrderByClause(sb.toString());
        return this;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria(this);
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
        rows = null;
        offset = null;
    }

    public static Criteria newAndCreateCriteria() {
        DiscountProductExample example = new DiscountProductExample();
        return example.createCriteria();
    }

    public DiscountProductExample when(boolean condition, IExampleWhen then) {
        if (condition) {
            then.example(this);
        }
        return this;
    }

    public DiscountProductExample when(boolean condition, IExampleWhen then, IExampleWhen otherwise) {
        if (condition) {
            then.example(this);
        } else {
            otherwise.example(this);
        }
        return this;
    }

    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    public Integer getOffset() {
        return this.offset;
    }

    public void setRows(Integer rows) {
        this.rows = rows;
    }

    public Integer getRows() {
        return this.rows;
    }

    public DiscountProductExample limit(Integer rows) {
        this.rows = rows;
        return this;
    }

    public DiscountProductExample limit(Integer offset, Integer rows) {
        this.offset = offset;
        this.rows = rows;
        return this;
    }

    public DiscountProductExample page(Integer page, Integer pageSize) {
        this.offset = page * pageSize;
        this.rows = pageSize;
        return this;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andProductIdIsNull() {
            addCriterion("discountproduct.ProductId is null");
            return (Criteria) this;
        }

        public Criteria andProductIdIsNotNull() {
            addCriterion("discountproduct.ProductId is not null");
            return (Criteria) this;
        }

        public Criteria andProductIdEqualTo(Integer value) {
            addCriterion("discountproduct.ProductId =", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.ProductId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductIdNotEqualTo(Integer value) {
            addCriterion("discountproduct.ProductId <>", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdNotEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.ProductId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductIdGreaterThan(Integer value) {
            addCriterion("discountproduct.ProductId >", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdGreaterThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.ProductId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("discountproduct.ProductId >=", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdGreaterThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.ProductId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductIdLessThan(Integer value) {
            addCriterion("discountproduct.ProductId <", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdLessThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.ProductId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductIdLessThanOrEqualTo(Integer value) {
            addCriterion("discountproduct.ProductId <=", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdLessThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.ProductId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductIdIn(List<Integer> values) {
            addCriterion("discountproduct.ProductId in", values, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdNotIn(List<Integer> values) {
            addCriterion("discountproduct.ProductId not in", values, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdBetween(Integer value1, Integer value2) {
            addCriterion("discountproduct.ProductId between", value1, value2, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdNotBetween(Integer value1, Integer value2) {
            addCriterion("discountproduct.ProductId not between", value1, value2, "productId");
            return (Criteria) this;
        }

        public Criteria andBrandIdIsNull() {
            addCriterion("discountproduct.BrandId is null");
            return (Criteria) this;
        }

        public Criteria andBrandIdIsNotNull() {
            addCriterion("discountproduct.BrandId is not null");
            return (Criteria) this;
        }

        public Criteria andBrandIdEqualTo(Integer value) {
            addCriterion("discountproduct.BrandId =", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.BrandId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBrandIdNotEqualTo(Integer value) {
            addCriterion("discountproduct.BrandId <>", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdNotEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.BrandId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBrandIdGreaterThan(Integer value) {
            addCriterion("discountproduct.BrandId >", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdGreaterThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.BrandId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBrandIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("discountproduct.BrandId >=", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdGreaterThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.BrandId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBrandIdLessThan(Integer value) {
            addCriterion("discountproduct.BrandId <", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdLessThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.BrandId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBrandIdLessThanOrEqualTo(Integer value) {
            addCriterion("discountproduct.BrandId <=", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdLessThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.BrandId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBrandIdIn(List<Integer> values) {
            addCriterion("discountproduct.BrandId in", values, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdNotIn(List<Integer> values) {
            addCriterion("discountproduct.BrandId not in", values, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdBetween(Integer value1, Integer value2) {
            addCriterion("discountproduct.BrandId between", value1, value2, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdNotBetween(Integer value1, Integer value2) {
            addCriterion("discountproduct.BrandId not between", value1, value2, "brandId");
            return (Criteria) this;
        }

        public Criteria andRegionTypeIsNull() {
            addCriterion("discountproduct.RegionType is null");
            return (Criteria) this;
        }

        public Criteria andRegionTypeIsNotNull() {
            addCriterion("discountproduct.RegionType is not null");
            return (Criteria) this;
        }

        public Criteria andRegionTypeEqualTo(Integer value) {
            addCriterion("discountproduct.RegionType =", value, "regionType");
            return (Criteria) this;
        }

        public Criteria andRegionTypeEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.RegionType = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRegionTypeNotEqualTo(Integer value) {
            addCriterion("discountproduct.RegionType <>", value, "regionType");
            return (Criteria) this;
        }

        public Criteria andRegionTypeNotEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.RegionType <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRegionTypeGreaterThan(Integer value) {
            addCriterion("discountproduct.RegionType >", value, "regionType");
            return (Criteria) this;
        }

        public Criteria andRegionTypeGreaterThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.RegionType > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRegionTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("discountproduct.RegionType >=", value, "regionType");
            return (Criteria) this;
        }

        public Criteria andRegionTypeGreaterThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.RegionType >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRegionTypeLessThan(Integer value) {
            addCriterion("discountproduct.RegionType <", value, "regionType");
            return (Criteria) this;
        }

        public Criteria andRegionTypeLessThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.RegionType < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRegionTypeLessThanOrEqualTo(Integer value) {
            addCriterion("discountproduct.RegionType <=", value, "regionType");
            return (Criteria) this;
        }

        public Criteria andRegionTypeLessThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.RegionType <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRegionTypeIn(List<Integer> values) {
            addCriterion("discountproduct.RegionType in", values, "regionType");
            return (Criteria) this;
        }

        public Criteria andRegionTypeNotIn(List<Integer> values) {
            addCriterion("discountproduct.RegionType not in", values, "regionType");
            return (Criteria) this;
        }

        public Criteria andRegionTypeBetween(Integer value1, Integer value2) {
            addCriterion("discountproduct.RegionType between", value1, value2, "regionType");
            return (Criteria) this;
        }

        public Criteria andRegionTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("discountproduct.RegionType not between", value1, value2, "regionType");
            return (Criteria) this;
        }

        public Criteria andDiscountModeIsNull() {
            addCriterion("discountproduct.DiscountMode is null");
            return (Criteria) this;
        }

        public Criteria andDiscountModeIsNotNull() {
            addCriterion("discountproduct.DiscountMode is not null");
            return (Criteria) this;
        }

        public Criteria andDiscountModeEqualTo(Integer value) {
            addCriterion("discountproduct.DiscountMode =", value, "discountMode");
            return (Criteria) this;
        }

        public Criteria andDiscountModeEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.DiscountMode = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDiscountModeNotEqualTo(Integer value) {
            addCriterion("discountproduct.DiscountMode <>", value, "discountMode");
            return (Criteria) this;
        }

        public Criteria andDiscountModeNotEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.DiscountMode <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDiscountModeGreaterThan(Integer value) {
            addCriterion("discountproduct.DiscountMode >", value, "discountMode");
            return (Criteria) this;
        }

        public Criteria andDiscountModeGreaterThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.DiscountMode > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDiscountModeGreaterThanOrEqualTo(Integer value) {
            addCriterion("discountproduct.DiscountMode >=", value, "discountMode");
            return (Criteria) this;
        }

        public Criteria andDiscountModeGreaterThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.DiscountMode >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDiscountModeLessThan(Integer value) {
            addCriterion("discountproduct.DiscountMode <", value, "discountMode");
            return (Criteria) this;
        }

        public Criteria andDiscountModeLessThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.DiscountMode < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDiscountModeLessThanOrEqualTo(Integer value) {
            addCriterion("discountproduct.DiscountMode <=", value, "discountMode");
            return (Criteria) this;
        }

        public Criteria andDiscountModeLessThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.DiscountMode <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDiscountModeIn(List<Integer> values) {
            addCriterion("discountproduct.DiscountMode in", values, "discountMode");
            return (Criteria) this;
        }

        public Criteria andDiscountModeNotIn(List<Integer> values) {
            addCriterion("discountproduct.DiscountMode not in", values, "discountMode");
            return (Criteria) this;
        }

        public Criteria andDiscountModeBetween(Integer value1, Integer value2) {
            addCriterion("discountproduct.DiscountMode between", value1, value2, "discountMode");
            return (Criteria) this;
        }

        public Criteria andDiscountModeNotBetween(Integer value1, Integer value2) {
            addCriterion("discountproduct.DiscountMode not between", value1, value2, "discountMode");
            return (Criteria) this;
        }

        public Criteria andServiceTypeIsNull() {
            addCriterion("discountproduct.ServiceType is null");
            return (Criteria) this;
        }

        public Criteria andServiceTypeIsNotNull() {
            addCriterion("discountproduct.ServiceType is not null");
            return (Criteria) this;
        }

        public Criteria andServiceTypeEqualTo(Integer value) {
            addCriterion("discountproduct.ServiceType =", value, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceTypeEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.ServiceType = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceTypeNotEqualTo(Integer value) {
            addCriterion("discountproduct.ServiceType <>", value, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceTypeNotEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.ServiceType <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceTypeGreaterThan(Integer value) {
            addCriterion("discountproduct.ServiceType >", value, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceTypeGreaterThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.ServiceType > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("discountproduct.ServiceType >=", value, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceTypeGreaterThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.ServiceType >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceTypeLessThan(Integer value) {
            addCriterion("discountproduct.ServiceType <", value, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceTypeLessThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.ServiceType < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceTypeLessThanOrEqualTo(Integer value) {
            addCriterion("discountproduct.ServiceType <=", value, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceTypeLessThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.ServiceType <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceTypeIn(List<Integer> values) {
            addCriterion("discountproduct.ServiceType in", values, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceTypeNotIn(List<Integer> values) {
            addCriterion("discountproduct.ServiceType not in", values, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceTypeBetween(Integer value1, Integer value2) {
            addCriterion("discountproduct.ServiceType between", value1, value2, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("discountproduct.ServiceType not between", value1, value2, "serviceType");
            return (Criteria) this;
        }

        public Criteria andServiceDataIdIsNull() {
            addCriterion("discountproduct.ServiceDataId is null");
            return (Criteria) this;
        }

        public Criteria andServiceDataIdIsNotNull() {
            addCriterion("discountproduct.ServiceDataId is not null");
            return (Criteria) this;
        }

        public Criteria andServiceDataIdEqualTo(String value) {
            addCriterion("discountproduct.ServiceDataId =", value, "serviceDataId");
            return (Criteria) this;
        }

        public Criteria andServiceDataIdEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.ServiceDataId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceDataIdNotEqualTo(String value) {
            addCriterion("discountproduct.ServiceDataId <>", value, "serviceDataId");
            return (Criteria) this;
        }

        public Criteria andServiceDataIdNotEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.ServiceDataId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceDataIdGreaterThan(String value) {
            addCriterion("discountproduct.ServiceDataId >", value, "serviceDataId");
            return (Criteria) this;
        }

        public Criteria andServiceDataIdGreaterThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.ServiceDataId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceDataIdGreaterThanOrEqualTo(String value) {
            addCriterion("discountproduct.ServiceDataId >=", value, "serviceDataId");
            return (Criteria) this;
        }

        public Criteria andServiceDataIdGreaterThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.ServiceDataId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceDataIdLessThan(String value) {
            addCriterion("discountproduct.ServiceDataId <", value, "serviceDataId");
            return (Criteria) this;
        }

        public Criteria andServiceDataIdLessThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.ServiceDataId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceDataIdLessThanOrEqualTo(String value) {
            addCriterion("discountproduct.ServiceDataId <=", value, "serviceDataId");
            return (Criteria) this;
        }

        public Criteria andServiceDataIdLessThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.ServiceDataId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andServiceDataIdLike(String value) {
            addCriterion("discountproduct.ServiceDataId like", value, "serviceDataId");
            return (Criteria) this;
        }

        public Criteria andServiceDataIdNotLike(String value) {
            addCriterion("discountproduct.ServiceDataId not like", value, "serviceDataId");
            return (Criteria) this;
        }

        public Criteria andServiceDataIdIn(List<String> values) {
            addCriterion("discountproduct.ServiceDataId in", values, "serviceDataId");
            return (Criteria) this;
        }

        public Criteria andServiceDataIdNotIn(List<String> values) {
            addCriterion("discountproduct.ServiceDataId not in", values, "serviceDataId");
            return (Criteria) this;
        }

        public Criteria andServiceDataIdBetween(String value1, String value2) {
            addCriterion("discountproduct.ServiceDataId between", value1, value2, "serviceDataId");
            return (Criteria) this;
        }

        public Criteria andServiceDataIdNotBetween(String value1, String value2) {
            addCriterion("discountproduct.ServiceDataId not between", value1, value2, "serviceDataId");
            return (Criteria) this;
        }

        public Criteria andNameIsNull() {
            addCriterion("discountproduct.`Name` is null");
            return (Criteria) this;
        }

        public Criteria andNameIsNotNull() {
            addCriterion("discountproduct.`Name` is not null");
            return (Criteria) this;
        }

        public Criteria andNameEqualTo(String value) {
            addCriterion("discountproduct.`Name` =", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.`Name` = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNameNotEqualTo(String value) {
            addCriterion("discountproduct.`Name` <>", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.`Name` <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNameGreaterThan(String value) {
            addCriterion("discountproduct.`Name` >", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.`Name` > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanOrEqualTo(String value) {
            addCriterion("discountproduct.`Name` >=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.`Name` >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNameLessThan(String value) {
            addCriterion("discountproduct.`Name` <", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.`Name` < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNameLessThanOrEqualTo(String value) {
            addCriterion("discountproduct.`Name` <=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.`Name` <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNameLike(String value) {
            addCriterion("discountproduct.`Name` like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotLike(String value) {
            addCriterion("discountproduct.`Name` not like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameIn(List<String> values) {
            addCriterion("discountproduct.`Name` in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotIn(List<String> values) {
            addCriterion("discountproduct.`Name` not in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameBetween(String value1, String value2) {
            addCriterion("discountproduct.`Name` between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotBetween(String value1, String value2) {
            addCriterion("discountproduct.`Name` not between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andSubTitleIsNull() {
            addCriterion("discountproduct.SubTitle is null");
            return (Criteria) this;
        }

        public Criteria andSubTitleIsNotNull() {
            addCriterion("discountproduct.SubTitle is not null");
            return (Criteria) this;
        }

        public Criteria andSubTitleEqualTo(String value) {
            addCriterion("discountproduct.SubTitle =", value, "subTitle");
            return (Criteria) this;
        }

        public Criteria andSubTitleEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.SubTitle = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSubTitleNotEqualTo(String value) {
            addCriterion("discountproduct.SubTitle <>", value, "subTitle");
            return (Criteria) this;
        }

        public Criteria andSubTitleNotEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.SubTitle <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSubTitleGreaterThan(String value) {
            addCriterion("discountproduct.SubTitle >", value, "subTitle");
            return (Criteria) this;
        }

        public Criteria andSubTitleGreaterThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.SubTitle > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSubTitleGreaterThanOrEqualTo(String value) {
            addCriterion("discountproduct.SubTitle >=", value, "subTitle");
            return (Criteria) this;
        }

        public Criteria andSubTitleGreaterThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.SubTitle >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSubTitleLessThan(String value) {
            addCriterion("discountproduct.SubTitle <", value, "subTitle");
            return (Criteria) this;
        }

        public Criteria andSubTitleLessThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.SubTitle < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSubTitleLessThanOrEqualTo(String value) {
            addCriterion("discountproduct.SubTitle <=", value, "subTitle");
            return (Criteria) this;
        }

        public Criteria andSubTitleLessThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.SubTitle <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSubTitleLike(String value) {
            addCriterion("discountproduct.SubTitle like", value, "subTitle");
            return (Criteria) this;
        }

        public Criteria andSubTitleNotLike(String value) {
            addCriterion("discountproduct.SubTitle not like", value, "subTitle");
            return (Criteria) this;
        }

        public Criteria andSubTitleIn(List<String> values) {
            addCriterion("discountproduct.SubTitle in", values, "subTitle");
            return (Criteria) this;
        }

        public Criteria andSubTitleNotIn(List<String> values) {
            addCriterion("discountproduct.SubTitle not in", values, "subTitle");
            return (Criteria) this;
        }

        public Criteria andSubTitleBetween(String value1, String value2) {
            addCriterion("discountproduct.SubTitle between", value1, value2, "subTitle");
            return (Criteria) this;
        }

        public Criteria andSubTitleNotBetween(String value1, String value2) {
            addCriterion("discountproduct.SubTitle not between", value1, value2, "subTitle");
            return (Criteria) this;
        }

        public Criteria andImageIsNull() {
            addCriterion("discountproduct.Image is null");
            return (Criteria) this;
        }

        public Criteria andImageIsNotNull() {
            addCriterion("discountproduct.Image is not null");
            return (Criteria) this;
        }

        public Criteria andImageEqualTo(String value) {
            addCriterion("discountproduct.Image =", value, "image");
            return (Criteria) this;
        }

        public Criteria andImageEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.Image = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andImageNotEqualTo(String value) {
            addCriterion("discountproduct.Image <>", value, "image");
            return (Criteria) this;
        }

        public Criteria andImageNotEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.Image <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andImageGreaterThan(String value) {
            addCriterion("discountproduct.Image >", value, "image");
            return (Criteria) this;
        }

        public Criteria andImageGreaterThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.Image > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andImageGreaterThanOrEqualTo(String value) {
            addCriterion("discountproduct.Image >=", value, "image");
            return (Criteria) this;
        }

        public Criteria andImageGreaterThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.Image >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andImageLessThan(String value) {
            addCriterion("discountproduct.Image <", value, "image");
            return (Criteria) this;
        }

        public Criteria andImageLessThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.Image < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andImageLessThanOrEqualTo(String value) {
            addCriterion("discountproduct.Image <=", value, "image");
            return (Criteria) this;
        }

        public Criteria andImageLessThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.Image <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andImageLike(String value) {
            addCriterion("discountproduct.Image like", value, "image");
            return (Criteria) this;
        }

        public Criteria andImageNotLike(String value) {
            addCriterion("discountproduct.Image not like", value, "image");
            return (Criteria) this;
        }

        public Criteria andImageIn(List<String> values) {
            addCriterion("discountproduct.Image in", values, "image");
            return (Criteria) this;
        }

        public Criteria andImageNotIn(List<String> values) {
            addCriterion("discountproduct.Image not in", values, "image");
            return (Criteria) this;
        }

        public Criteria andImageBetween(String value1, String value2) {
            addCriterion("discountproduct.Image between", value1, value2, "image");
            return (Criteria) this;
        }

        public Criteria andImageNotBetween(String value1, String value2) {
            addCriterion("discountproduct.Image not between", value1, value2, "image");
            return (Criteria) this;
        }

        public Criteria andShelfLifeStrategyIsNull() {
            addCriterion("discountproduct.ShelfLifeStrategy is null");
            return (Criteria) this;
        }

        public Criteria andShelfLifeStrategyIsNotNull() {
            addCriterion("discountproduct.ShelfLifeStrategy is not null");
            return (Criteria) this;
        }

        public Criteria andShelfLifeStrategyEqualTo(Integer value) {
            addCriterion("discountproduct.ShelfLifeStrategy =", value, "shelfLifeStrategy");
            return (Criteria) this;
        }

        public Criteria andShelfLifeStrategyEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.ShelfLifeStrategy = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShelfLifeStrategyNotEqualTo(Integer value) {
            addCriterion("discountproduct.ShelfLifeStrategy <>", value, "shelfLifeStrategy");
            return (Criteria) this;
        }

        public Criteria andShelfLifeStrategyNotEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.ShelfLifeStrategy <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShelfLifeStrategyGreaterThan(Integer value) {
            addCriterion("discountproduct.ShelfLifeStrategy >", value, "shelfLifeStrategy");
            return (Criteria) this;
        }

        public Criteria andShelfLifeStrategyGreaterThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.ShelfLifeStrategy > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShelfLifeStrategyGreaterThanOrEqualTo(Integer value) {
            addCriterion("discountproduct.ShelfLifeStrategy >=", value, "shelfLifeStrategy");
            return (Criteria) this;
        }

        public Criteria andShelfLifeStrategyGreaterThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.ShelfLifeStrategy >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShelfLifeStrategyLessThan(Integer value) {
            addCriterion("discountproduct.ShelfLifeStrategy <", value, "shelfLifeStrategy");
            return (Criteria) this;
        }

        public Criteria andShelfLifeStrategyLessThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.ShelfLifeStrategy < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShelfLifeStrategyLessThanOrEqualTo(Integer value) {
            addCriterion("discountproduct.ShelfLifeStrategy <=", value, "shelfLifeStrategy");
            return (Criteria) this;
        }

        public Criteria andShelfLifeStrategyLessThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.ShelfLifeStrategy <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShelfLifeStrategyIn(List<Integer> values) {
            addCriterion("discountproduct.ShelfLifeStrategy in", values, "shelfLifeStrategy");
            return (Criteria) this;
        }

        public Criteria andShelfLifeStrategyNotIn(List<Integer> values) {
            addCriterion("discountproduct.ShelfLifeStrategy not in", values, "shelfLifeStrategy");
            return (Criteria) this;
        }

        public Criteria andShelfLifeStrategyBetween(Integer value1, Integer value2) {
            addCriterion("discountproduct.ShelfLifeStrategy between", value1, value2, "shelfLifeStrategy");
            return (Criteria) this;
        }

        public Criteria andShelfLifeStrategyNotBetween(Integer value1, Integer value2) {
            addCriterion("discountproduct.ShelfLifeStrategy not between", value1, value2, "shelfLifeStrategy");
            return (Criteria) this;
        }

        public Criteria andShelfLifeDescribeIsNull() {
            addCriterion("discountproduct.ShelfLifeDescribe is null");
            return (Criteria) this;
        }

        public Criteria andShelfLifeDescribeIsNotNull() {
            addCriterion("discountproduct.ShelfLifeDescribe is not null");
            return (Criteria) this;
        }

        public Criteria andShelfLifeDescribeEqualTo(String value) {
            addCriterion("discountproduct.ShelfLifeDescribe =", value, "shelfLifeDescribe");
            return (Criteria) this;
        }

        public Criteria andShelfLifeDescribeEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.ShelfLifeDescribe = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShelfLifeDescribeNotEqualTo(String value) {
            addCriterion("discountproduct.ShelfLifeDescribe <>", value, "shelfLifeDescribe");
            return (Criteria) this;
        }

        public Criteria andShelfLifeDescribeNotEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.ShelfLifeDescribe <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShelfLifeDescribeGreaterThan(String value) {
            addCriterion("discountproduct.ShelfLifeDescribe >", value, "shelfLifeDescribe");
            return (Criteria) this;
        }

        public Criteria andShelfLifeDescribeGreaterThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.ShelfLifeDescribe > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShelfLifeDescribeGreaterThanOrEqualTo(String value) {
            addCriterion("discountproduct.ShelfLifeDescribe >=", value, "shelfLifeDescribe");
            return (Criteria) this;
        }

        public Criteria andShelfLifeDescribeGreaterThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.ShelfLifeDescribe >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShelfLifeDescribeLessThan(String value) {
            addCriterion("discountproduct.ShelfLifeDescribe <", value, "shelfLifeDescribe");
            return (Criteria) this;
        }

        public Criteria andShelfLifeDescribeLessThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.ShelfLifeDescribe < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShelfLifeDescribeLessThanOrEqualTo(String value) {
            addCriterion("discountproduct.ShelfLifeDescribe <=", value, "shelfLifeDescribe");
            return (Criteria) this;
        }

        public Criteria andShelfLifeDescribeLessThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.ShelfLifeDescribe <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShelfLifeDescribeLike(String value) {
            addCriterion("discountproduct.ShelfLifeDescribe like", value, "shelfLifeDescribe");
            return (Criteria) this;
        }

        public Criteria andShelfLifeDescribeNotLike(String value) {
            addCriterion("discountproduct.ShelfLifeDescribe not like", value, "shelfLifeDescribe");
            return (Criteria) this;
        }

        public Criteria andShelfLifeDescribeIn(List<String> values) {
            addCriterion("discountproduct.ShelfLifeDescribe in", values, "shelfLifeDescribe");
            return (Criteria) this;
        }

        public Criteria andShelfLifeDescribeNotIn(List<String> values) {
            addCriterion("discountproduct.ShelfLifeDescribe not in", values, "shelfLifeDescribe");
            return (Criteria) this;
        }

        public Criteria andShelfLifeDescribeBetween(String value1, String value2) {
            addCriterion("discountproduct.ShelfLifeDescribe between", value1, value2, "shelfLifeDescribe");
            return (Criteria) this;
        }

        public Criteria andShelfLifeDescribeNotBetween(String value1, String value2) {
            addCriterion("discountproduct.ShelfLifeDescribe not between", value1, value2, "shelfLifeDescribe");
            return (Criteria) this;
        }

        public Criteria andFixedEndShelfLifeIsNull() {
            addCriterion("discountproduct.FixedEndShelfLife is null");
            return (Criteria) this;
        }

        public Criteria andFixedEndShelfLifeIsNotNull() {
            addCriterion("discountproduct.FixedEndShelfLife is not null");
            return (Criteria) this;
        }

        public Criteria andFixedEndShelfLifeEqualTo(Date value) {
            addCriterion("discountproduct.FixedEndShelfLife =", value, "fixedEndShelfLife");
            return (Criteria) this;
        }

        public Criteria andFixedEndShelfLifeEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.FixedEndShelfLife = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFixedEndShelfLifeNotEqualTo(Date value) {
            addCriterion("discountproduct.FixedEndShelfLife <>", value, "fixedEndShelfLife");
            return (Criteria) this;
        }

        public Criteria andFixedEndShelfLifeNotEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.FixedEndShelfLife <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFixedEndShelfLifeGreaterThan(Date value) {
            addCriterion("discountproduct.FixedEndShelfLife >", value, "fixedEndShelfLife");
            return (Criteria) this;
        }

        public Criteria andFixedEndShelfLifeGreaterThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.FixedEndShelfLife > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFixedEndShelfLifeGreaterThanOrEqualTo(Date value) {
            addCriterion("discountproduct.FixedEndShelfLife >=", value, "fixedEndShelfLife");
            return (Criteria) this;
        }

        public Criteria andFixedEndShelfLifeGreaterThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.FixedEndShelfLife >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFixedEndShelfLifeLessThan(Date value) {
            addCriterion("discountproduct.FixedEndShelfLife <", value, "fixedEndShelfLife");
            return (Criteria) this;
        }

        public Criteria andFixedEndShelfLifeLessThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.FixedEndShelfLife < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFixedEndShelfLifeLessThanOrEqualTo(Date value) {
            addCriterion("discountproduct.FixedEndShelfLife <=", value, "fixedEndShelfLife");
            return (Criteria) this;
        }

        public Criteria andFixedEndShelfLifeLessThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.FixedEndShelfLife <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andFixedEndShelfLifeIn(List<Date> values) {
            addCriterion("discountproduct.FixedEndShelfLife in", values, "fixedEndShelfLife");
            return (Criteria) this;
        }

        public Criteria andFixedEndShelfLifeNotIn(List<Date> values) {
            addCriterion("discountproduct.FixedEndShelfLife not in", values, "fixedEndShelfLife");
            return (Criteria) this;
        }

        public Criteria andFixedEndShelfLifeBetween(Date value1, Date value2) {
            addCriterion("discountproduct.FixedEndShelfLife between", value1, value2, "fixedEndShelfLife");
            return (Criteria) this;
        }

        public Criteria andFixedEndShelfLifeNotBetween(Date value1, Date value2) {
            addCriterion("discountproduct.FixedEndShelfLife not between", value1, value2, "fixedEndShelfLife");
            return (Criteria) this;
        }

        public Criteria andDynamicShelfLifeTypeIsNull() {
            addCriterion("discountproduct.DynamicShelfLifeType is null");
            return (Criteria) this;
        }

        public Criteria andDynamicShelfLifeTypeIsNotNull() {
            addCriterion("discountproduct.DynamicShelfLifeType is not null");
            return (Criteria) this;
        }

        public Criteria andDynamicShelfLifeTypeEqualTo(Integer value) {
            addCriterion("discountproduct.DynamicShelfLifeType =", value, "dynamicShelfLifeType");
            return (Criteria) this;
        }

        public Criteria andDynamicShelfLifeTypeEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.DynamicShelfLifeType = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDynamicShelfLifeTypeNotEqualTo(Integer value) {
            addCriterion("discountproduct.DynamicShelfLifeType <>", value, "dynamicShelfLifeType");
            return (Criteria) this;
        }

        public Criteria andDynamicShelfLifeTypeNotEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.DynamicShelfLifeType <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDynamicShelfLifeTypeGreaterThan(Integer value) {
            addCriterion("discountproduct.DynamicShelfLifeType >", value, "dynamicShelfLifeType");
            return (Criteria) this;
        }

        public Criteria andDynamicShelfLifeTypeGreaterThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.DynamicShelfLifeType > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDynamicShelfLifeTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("discountproduct.DynamicShelfLifeType >=", value, "dynamicShelfLifeType");
            return (Criteria) this;
        }

        public Criteria andDynamicShelfLifeTypeGreaterThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.DynamicShelfLifeType >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDynamicShelfLifeTypeLessThan(Integer value) {
            addCriterion("discountproduct.DynamicShelfLifeType <", value, "dynamicShelfLifeType");
            return (Criteria) this;
        }

        public Criteria andDynamicShelfLifeTypeLessThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.DynamicShelfLifeType < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDynamicShelfLifeTypeLessThanOrEqualTo(Integer value) {
            addCriterion("discountproduct.DynamicShelfLifeType <=", value, "dynamicShelfLifeType");
            return (Criteria) this;
        }

        public Criteria andDynamicShelfLifeTypeLessThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.DynamicShelfLifeType <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDynamicShelfLifeTypeIn(List<Integer> values) {
            addCriterion("discountproduct.DynamicShelfLifeType in", values, "dynamicShelfLifeType");
            return (Criteria) this;
        }

        public Criteria andDynamicShelfLifeTypeNotIn(List<Integer> values) {
            addCriterion("discountproduct.DynamicShelfLifeType not in", values, "dynamicShelfLifeType");
            return (Criteria) this;
        }

        public Criteria andDynamicShelfLifeTypeBetween(Integer value1, Integer value2) {
            addCriterion("discountproduct.DynamicShelfLifeType between", value1, value2, "dynamicShelfLifeType");
            return (Criteria) this;
        }

        public Criteria andDynamicShelfLifeTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("discountproduct.DynamicShelfLifeType not between", value1, value2, "dynamicShelfLifeType");
            return (Criteria) this;
        }

        public Criteria andDynamicShelfLifeValueIsNull() {
            addCriterion("discountproduct.DynamicShelfLifeValue is null");
            return (Criteria) this;
        }

        public Criteria andDynamicShelfLifeValueIsNotNull() {
            addCriterion("discountproduct.DynamicShelfLifeValue is not null");
            return (Criteria) this;
        }

        public Criteria andDynamicShelfLifeValueEqualTo(Integer value) {
            addCriterion("discountproduct.DynamicShelfLifeValue =", value, "dynamicShelfLifeValue");
            return (Criteria) this;
        }

        public Criteria andDynamicShelfLifeValueEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.DynamicShelfLifeValue = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDynamicShelfLifeValueNotEqualTo(Integer value) {
            addCriterion("discountproduct.DynamicShelfLifeValue <>", value, "dynamicShelfLifeValue");
            return (Criteria) this;
        }

        public Criteria andDynamicShelfLifeValueNotEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.DynamicShelfLifeValue <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDynamicShelfLifeValueGreaterThan(Integer value) {
            addCriterion("discountproduct.DynamicShelfLifeValue >", value, "dynamicShelfLifeValue");
            return (Criteria) this;
        }

        public Criteria andDynamicShelfLifeValueGreaterThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.DynamicShelfLifeValue > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDynamicShelfLifeValueGreaterThanOrEqualTo(Integer value) {
            addCriterion("discountproduct.DynamicShelfLifeValue >=", value, "dynamicShelfLifeValue");
            return (Criteria) this;
        }

        public Criteria andDynamicShelfLifeValueGreaterThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.DynamicShelfLifeValue >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDynamicShelfLifeValueLessThan(Integer value) {
            addCriterion("discountproduct.DynamicShelfLifeValue <", value, "dynamicShelfLifeValue");
            return (Criteria) this;
        }

        public Criteria andDynamicShelfLifeValueLessThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.DynamicShelfLifeValue < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDynamicShelfLifeValueLessThanOrEqualTo(Integer value) {
            addCriterion("discountproduct.DynamicShelfLifeValue <=", value, "dynamicShelfLifeValue");
            return (Criteria) this;
        }

        public Criteria andDynamicShelfLifeValueLessThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.DynamicShelfLifeValue <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDynamicShelfLifeValueIn(List<Integer> values) {
            addCriterion("discountproduct.DynamicShelfLifeValue in", values, "dynamicShelfLifeValue");
            return (Criteria) this;
        }

        public Criteria andDynamicShelfLifeValueNotIn(List<Integer> values) {
            addCriterion("discountproduct.DynamicShelfLifeValue not in", values, "dynamicShelfLifeValue");
            return (Criteria) this;
        }

        public Criteria andDynamicShelfLifeValueBetween(Integer value1, Integer value2) {
            addCriterion("discountproduct.DynamicShelfLifeValue between", value1, value2, "dynamicShelfLifeValue");
            return (Criteria) this;
        }

        public Criteria andDynamicShelfLifeValueNotBetween(Integer value1, Integer value2) {
            addCriterion("discountproduct.DynamicShelfLifeValue not between", value1, value2, "dynamicShelfLifeValue");
            return (Criteria) this;
        }

        public Criteria andStartReleaseDateIsNull() {
            addCriterion("discountproduct.StartReleaseDate is null");
            return (Criteria) this;
        }

        public Criteria andStartReleaseDateIsNotNull() {
            addCriterion("discountproduct.StartReleaseDate is not null");
            return (Criteria) this;
        }

        public Criteria andStartReleaseDateEqualTo(Date value) {
            addCriterion("discountproduct.StartReleaseDate =", value, "startReleaseDate");
            return (Criteria) this;
        }

        public Criteria andStartReleaseDateEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.StartReleaseDate = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStartReleaseDateNotEqualTo(Date value) {
            addCriterion("discountproduct.StartReleaseDate <>", value, "startReleaseDate");
            return (Criteria) this;
        }

        public Criteria andStartReleaseDateNotEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.StartReleaseDate <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStartReleaseDateGreaterThan(Date value) {
            addCriterion("discountproduct.StartReleaseDate >", value, "startReleaseDate");
            return (Criteria) this;
        }

        public Criteria andStartReleaseDateGreaterThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.StartReleaseDate > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStartReleaseDateGreaterThanOrEqualTo(Date value) {
            addCriterion("discountproduct.StartReleaseDate >=", value, "startReleaseDate");
            return (Criteria) this;
        }

        public Criteria andStartReleaseDateGreaterThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.StartReleaseDate >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStartReleaseDateLessThan(Date value) {
            addCriterion("discountproduct.StartReleaseDate <", value, "startReleaseDate");
            return (Criteria) this;
        }

        public Criteria andStartReleaseDateLessThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.StartReleaseDate < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStartReleaseDateLessThanOrEqualTo(Date value) {
            addCriterion("discountproduct.StartReleaseDate <=", value, "startReleaseDate");
            return (Criteria) this;
        }

        public Criteria andStartReleaseDateLessThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.StartReleaseDate <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStartReleaseDateIn(List<Date> values) {
            addCriterion("discountproduct.StartReleaseDate in", values, "startReleaseDate");
            return (Criteria) this;
        }

        public Criteria andStartReleaseDateNotIn(List<Date> values) {
            addCriterion("discountproduct.StartReleaseDate not in", values, "startReleaseDate");
            return (Criteria) this;
        }

        public Criteria andStartReleaseDateBetween(Date value1, Date value2) {
            addCriterion("discountproduct.StartReleaseDate between", value1, value2, "startReleaseDate");
            return (Criteria) this;
        }

        public Criteria andStartReleaseDateNotBetween(Date value1, Date value2) {
            addCriterion("discountproduct.StartReleaseDate not between", value1, value2, "startReleaseDate");
            return (Criteria) this;
        }

        public Criteria andEndReleaseDateIsNull() {
            addCriterion("discountproduct.EndReleaseDate is null");
            return (Criteria) this;
        }

        public Criteria andEndReleaseDateIsNotNull() {
            addCriterion("discountproduct.EndReleaseDate is not null");
            return (Criteria) this;
        }

        public Criteria andEndReleaseDateEqualTo(Date value) {
            addCriterion("discountproduct.EndReleaseDate =", value, "endReleaseDate");
            return (Criteria) this;
        }

        public Criteria andEndReleaseDateEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.EndReleaseDate = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andEndReleaseDateNotEqualTo(Date value) {
            addCriterion("discountproduct.EndReleaseDate <>", value, "endReleaseDate");
            return (Criteria) this;
        }

        public Criteria andEndReleaseDateNotEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.EndReleaseDate <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andEndReleaseDateGreaterThan(Date value) {
            addCriterion("discountproduct.EndReleaseDate >", value, "endReleaseDate");
            return (Criteria) this;
        }

        public Criteria andEndReleaseDateGreaterThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.EndReleaseDate > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andEndReleaseDateGreaterThanOrEqualTo(Date value) {
            addCriterion("discountproduct.EndReleaseDate >=", value, "endReleaseDate");
            return (Criteria) this;
        }

        public Criteria andEndReleaseDateGreaterThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.EndReleaseDate >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andEndReleaseDateLessThan(Date value) {
            addCriterion("discountproduct.EndReleaseDate <", value, "endReleaseDate");
            return (Criteria) this;
        }

        public Criteria andEndReleaseDateLessThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.EndReleaseDate < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andEndReleaseDateLessThanOrEqualTo(Date value) {
            addCriterion("discountproduct.EndReleaseDate <=", value, "endReleaseDate");
            return (Criteria) this;
        }

        public Criteria andEndReleaseDateLessThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.EndReleaseDate <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andEndReleaseDateIn(List<Date> values) {
            addCriterion("discountproduct.EndReleaseDate in", values, "endReleaseDate");
            return (Criteria) this;
        }

        public Criteria andEndReleaseDateNotIn(List<Date> values) {
            addCriterion("discountproduct.EndReleaseDate not in", values, "endReleaseDate");
            return (Criteria) this;
        }

        public Criteria andEndReleaseDateBetween(Date value1, Date value2) {
            addCriterion("discountproduct.EndReleaseDate between", value1, value2, "endReleaseDate");
            return (Criteria) this;
        }

        public Criteria andEndReleaseDateNotBetween(Date value1, Date value2) {
            addCriterion("discountproduct.EndReleaseDate not between", value1, value2, "endReleaseDate");
            return (Criteria) this;
        }

        public Criteria andStartSalesDateIsNull() {
            addCriterion("discountproduct.StartSalesDate is null");
            return (Criteria) this;
        }

        public Criteria andStartSalesDateIsNotNull() {
            addCriterion("discountproduct.StartSalesDate is not null");
            return (Criteria) this;
        }

        public Criteria andStartSalesDateEqualTo(Date value) {
            addCriterion("discountproduct.StartSalesDate =", value, "startSalesDate");
            return (Criteria) this;
        }

        public Criteria andStartSalesDateEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.StartSalesDate = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStartSalesDateNotEqualTo(Date value) {
            addCriterion("discountproduct.StartSalesDate <>", value, "startSalesDate");
            return (Criteria) this;
        }

        public Criteria andStartSalesDateNotEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.StartSalesDate <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStartSalesDateGreaterThan(Date value) {
            addCriterion("discountproduct.StartSalesDate >", value, "startSalesDate");
            return (Criteria) this;
        }

        public Criteria andStartSalesDateGreaterThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.StartSalesDate > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStartSalesDateGreaterThanOrEqualTo(Date value) {
            addCriterion("discountproduct.StartSalesDate >=", value, "startSalesDate");
            return (Criteria) this;
        }

        public Criteria andStartSalesDateGreaterThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.StartSalesDate >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStartSalesDateLessThan(Date value) {
            addCriterion("discountproduct.StartSalesDate <", value, "startSalesDate");
            return (Criteria) this;
        }

        public Criteria andStartSalesDateLessThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.StartSalesDate < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStartSalesDateLessThanOrEqualTo(Date value) {
            addCriterion("discountproduct.StartSalesDate <=", value, "startSalesDate");
            return (Criteria) this;
        }

        public Criteria andStartSalesDateLessThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.StartSalesDate <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStartSalesDateIn(List<Date> values) {
            addCriterion("discountproduct.StartSalesDate in", values, "startSalesDate");
            return (Criteria) this;
        }

        public Criteria andStartSalesDateNotIn(List<Date> values) {
            addCriterion("discountproduct.StartSalesDate not in", values, "startSalesDate");
            return (Criteria) this;
        }

        public Criteria andStartSalesDateBetween(Date value1, Date value2) {
            addCriterion("discountproduct.StartSalesDate between", value1, value2, "startSalesDate");
            return (Criteria) this;
        }

        public Criteria andStartSalesDateNotBetween(Date value1, Date value2) {
            addCriterion("discountproduct.StartSalesDate not between", value1, value2, "startSalesDate");
            return (Criteria) this;
        }

        public Criteria andEndSalesDateIsNull() {
            addCriterion("discountproduct.EndSalesDate is null");
            return (Criteria) this;
        }

        public Criteria andEndSalesDateIsNotNull() {
            addCriterion("discountproduct.EndSalesDate is not null");
            return (Criteria) this;
        }

        public Criteria andEndSalesDateEqualTo(Date value) {
            addCriterion("discountproduct.EndSalesDate =", value, "endSalesDate");
            return (Criteria) this;
        }

        public Criteria andEndSalesDateEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.EndSalesDate = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andEndSalesDateNotEqualTo(Date value) {
            addCriterion("discountproduct.EndSalesDate <>", value, "endSalesDate");
            return (Criteria) this;
        }

        public Criteria andEndSalesDateNotEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.EndSalesDate <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andEndSalesDateGreaterThan(Date value) {
            addCriterion("discountproduct.EndSalesDate >", value, "endSalesDate");
            return (Criteria) this;
        }

        public Criteria andEndSalesDateGreaterThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.EndSalesDate > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andEndSalesDateGreaterThanOrEqualTo(Date value) {
            addCriterion("discountproduct.EndSalesDate >=", value, "endSalesDate");
            return (Criteria) this;
        }

        public Criteria andEndSalesDateGreaterThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.EndSalesDate >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andEndSalesDateLessThan(Date value) {
            addCriterion("discountproduct.EndSalesDate <", value, "endSalesDate");
            return (Criteria) this;
        }

        public Criteria andEndSalesDateLessThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.EndSalesDate < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andEndSalesDateLessThanOrEqualTo(Date value) {
            addCriterion("discountproduct.EndSalesDate <=", value, "endSalesDate");
            return (Criteria) this;
        }

        public Criteria andEndSalesDateLessThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.EndSalesDate <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andEndSalesDateIn(List<Date> values) {
            addCriterion("discountproduct.EndSalesDate in", values, "endSalesDate");
            return (Criteria) this;
        }

        public Criteria andEndSalesDateNotIn(List<Date> values) {
            addCriterion("discountproduct.EndSalesDate not in", values, "endSalesDate");
            return (Criteria) this;
        }

        public Criteria andEndSalesDateBetween(Date value1, Date value2) {
            addCriterion("discountproduct.EndSalesDate between", value1, value2, "endSalesDate");
            return (Criteria) this;
        }

        public Criteria andEndSalesDateNotBetween(Date value1, Date value2) {
            addCriterion("discountproduct.EndSalesDate not between", value1, value2, "endSalesDate");
            return (Criteria) this;
        }

        public Criteria andBrandWeightIsNull() {
            addCriterion("discountproduct.BrandWeight is null");
            return (Criteria) this;
        }

        public Criteria andBrandWeightIsNotNull() {
            addCriterion("discountproduct.BrandWeight is not null");
            return (Criteria) this;
        }

        public Criteria andBrandWeightEqualTo(Integer value) {
            addCriterion("discountproduct.BrandWeight =", value, "brandWeight");
            return (Criteria) this;
        }

        public Criteria andBrandWeightEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.BrandWeight = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBrandWeightNotEqualTo(Integer value) {
            addCriterion("discountproduct.BrandWeight <>", value, "brandWeight");
            return (Criteria) this;
        }

        public Criteria andBrandWeightNotEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.BrandWeight <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBrandWeightGreaterThan(Integer value) {
            addCriterion("discountproduct.BrandWeight >", value, "brandWeight");
            return (Criteria) this;
        }

        public Criteria andBrandWeightGreaterThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.BrandWeight > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBrandWeightGreaterThanOrEqualTo(Integer value) {
            addCriterion("discountproduct.BrandWeight >=", value, "brandWeight");
            return (Criteria) this;
        }

        public Criteria andBrandWeightGreaterThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.BrandWeight >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBrandWeightLessThan(Integer value) {
            addCriterion("discountproduct.BrandWeight <", value, "brandWeight");
            return (Criteria) this;
        }

        public Criteria andBrandWeightLessThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.BrandWeight < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBrandWeightLessThanOrEqualTo(Integer value) {
            addCriterion("discountproduct.BrandWeight <=", value, "brandWeight");
            return (Criteria) this;
        }

        public Criteria andBrandWeightLessThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.BrandWeight <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andBrandWeightIn(List<Integer> values) {
            addCriterion("discountproduct.BrandWeight in", values, "brandWeight");
            return (Criteria) this;
        }

        public Criteria andBrandWeightNotIn(List<Integer> values) {
            addCriterion("discountproduct.BrandWeight not in", values, "brandWeight");
            return (Criteria) this;
        }

        public Criteria andBrandWeightBetween(Integer value1, Integer value2) {
            addCriterion("discountproduct.BrandWeight between", value1, value2, "brandWeight");
            return (Criteria) this;
        }

        public Criteria andBrandWeightNotBetween(Integer value1, Integer value2) {
            addCriterion("discountproduct.BrandWeight not between", value1, value2, "brandWeight");
            return (Criteria) this;
        }

        public Criteria andIsNewIsNull() {
            addCriterion("discountproduct.IsNew is null");
            return (Criteria) this;
        }

        public Criteria andIsNewIsNotNull() {
            addCriterion("discountproduct.IsNew is not null");
            return (Criteria) this;
        }

        public Criteria andIsNewEqualTo(Boolean value) {
            addCriterion("discountproduct.IsNew =", value, "isNew");
            return (Criteria) this;
        }

        public Criteria andIsNewEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.IsNew = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIsNewNotEqualTo(Boolean value) {
            addCriterion("discountproduct.IsNew <>", value, "isNew");
            return (Criteria) this;
        }

        public Criteria andIsNewNotEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.IsNew <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIsNewGreaterThan(Boolean value) {
            addCriterion("discountproduct.IsNew >", value, "isNew");
            return (Criteria) this;
        }

        public Criteria andIsNewGreaterThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.IsNew > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIsNewGreaterThanOrEqualTo(Boolean value) {
            addCriterion("discountproduct.IsNew >=", value, "isNew");
            return (Criteria) this;
        }

        public Criteria andIsNewGreaterThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.IsNew >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIsNewLessThan(Boolean value) {
            addCriterion("discountproduct.IsNew <", value, "isNew");
            return (Criteria) this;
        }

        public Criteria andIsNewLessThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.IsNew < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIsNewLessThanOrEqualTo(Boolean value) {
            addCriterion("discountproduct.IsNew <=", value, "isNew");
            return (Criteria) this;
        }

        public Criteria andIsNewLessThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.IsNew <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIsNewIn(List<Boolean> values) {
            addCriterion("discountproduct.IsNew in", values, "isNew");
            return (Criteria) this;
        }

        public Criteria andIsNewNotIn(List<Boolean> values) {
            addCriterion("discountproduct.IsNew not in", values, "isNew");
            return (Criteria) this;
        }

        public Criteria andIsNewBetween(Boolean value1, Boolean value2) {
            addCriterion("discountproduct.IsNew between", value1, value2, "isNew");
            return (Criteria) this;
        }

        public Criteria andIsNewNotBetween(Boolean value1, Boolean value2) {
            addCriterion("discountproduct.IsNew not between", value1, value2, "isNew");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("discountproduct.`Status` is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("discountproduct.`Status` is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("discountproduct.`Status` =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.`Status` = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("discountproduct.`Status` <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.`Status` <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("discountproduct.`Status` >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.`Status` > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("discountproduct.`Status` >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.`Status` >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("discountproduct.`Status` <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.`Status` < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("discountproduct.`Status` <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.`Status` <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("discountproduct.`Status` in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("discountproduct.`Status` not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("discountproduct.`Status` between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("discountproduct.`Status` not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andAvailableStatusIsNull() {
            addCriterion("discountproduct.AvailableStatus is null");
            return (Criteria) this;
        }

        public Criteria andAvailableStatusIsNotNull() {
            addCriterion("discountproduct.AvailableStatus is not null");
            return (Criteria) this;
        }

        public Criteria andAvailableStatusEqualTo(Integer value) {
            addCriterion("discountproduct.AvailableStatus =", value, "availableStatus");
            return (Criteria) this;
        }

        public Criteria andAvailableStatusEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.AvailableStatus = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAvailableStatusNotEqualTo(Integer value) {
            addCriterion("discountproduct.AvailableStatus <>", value, "availableStatus");
            return (Criteria) this;
        }

        public Criteria andAvailableStatusNotEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.AvailableStatus <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAvailableStatusGreaterThan(Integer value) {
            addCriterion("discountproduct.AvailableStatus >", value, "availableStatus");
            return (Criteria) this;
        }

        public Criteria andAvailableStatusGreaterThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.AvailableStatus > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAvailableStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("discountproduct.AvailableStatus >=", value, "availableStatus");
            return (Criteria) this;
        }

        public Criteria andAvailableStatusGreaterThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.AvailableStatus >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAvailableStatusLessThan(Integer value) {
            addCriterion("discountproduct.AvailableStatus <", value, "availableStatus");
            return (Criteria) this;
        }

        public Criteria andAvailableStatusLessThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.AvailableStatus < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAvailableStatusLessThanOrEqualTo(Integer value) {
            addCriterion("discountproduct.AvailableStatus <=", value, "availableStatus");
            return (Criteria) this;
        }

        public Criteria andAvailableStatusLessThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.AvailableStatus <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andAvailableStatusIn(List<Integer> values) {
            addCriterion("discountproduct.AvailableStatus in", values, "availableStatus");
            return (Criteria) this;
        }

        public Criteria andAvailableStatusNotIn(List<Integer> values) {
            addCriterion("discountproduct.AvailableStatus not in", values, "availableStatus");
            return (Criteria) this;
        }

        public Criteria andAvailableStatusBetween(Integer value1, Integer value2) {
            addCriterion("discountproduct.AvailableStatus between", value1, value2, "availableStatus");
            return (Criteria) this;
        }

        public Criteria andAvailableStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("discountproduct.AvailableStatus not between", value1, value2, "availableStatus");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNull() {
            addCriterion("discountproduct.Deleted is null");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNotNull() {
            addCriterion("discountproduct.Deleted is not null");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualTo(Boolean value) {
            addCriterion("discountproduct.Deleted =", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.Deleted = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualTo(Boolean value) {
            addCriterion("discountproduct.Deleted <>", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.Deleted <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThan(Boolean value) {
            addCriterion("discountproduct.Deleted >", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.Deleted > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualTo(Boolean value) {
            addCriterion("discountproduct.Deleted >=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.Deleted >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedLessThan(Boolean value) {
            addCriterion("discountproduct.Deleted <", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.Deleted < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualTo(Boolean value) {
            addCriterion("discountproduct.Deleted <=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.Deleted <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedIn(List<Boolean> values) {
            addCriterion("discountproduct.Deleted in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotIn(List<Boolean> values) {
            addCriterion("discountproduct.Deleted not in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedBetween(Boolean value1, Boolean value2) {
            addCriterion("discountproduct.Deleted between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotBetween(Boolean value1, Boolean value2) {
            addCriterion("discountproduct.Deleted not between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNull() {
            addCriterion("discountproduct.`CreateUser` is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNotNull() {
            addCriterion("discountproduct.`CreateUser` is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualTo(String value) {
            addCriterion("discountproduct.`CreateUser` =", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.`CreateUser` = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualTo(String value) {
            addCriterion("discountproduct.`CreateUser` <>", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.`CreateUser` <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThan(String value) {
            addCriterion("discountproduct.`CreateUser` >", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.`CreateUser` > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualTo(String value) {
            addCriterion("discountproduct.`CreateUser` >=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.`CreateUser` >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThan(String value) {
            addCriterion("discountproduct.`CreateUser` <", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.`CreateUser` < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualTo(String value) {
            addCriterion("discountproduct.`CreateUser` <=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.`CreateUser` <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLike(String value) {
            addCriterion("discountproduct.`CreateUser` like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotLike(String value) {
            addCriterion("discountproduct.`CreateUser` not like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserIn(List<String> values) {
            addCriterion("discountproduct.`CreateUser` in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotIn(List<String> values) {
            addCriterion("discountproduct.`CreateUser` not in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserBetween(String value1, String value2) {
            addCriterion("discountproduct.`CreateUser` between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotBetween(String value1, String value2) {
            addCriterion("discountproduct.`CreateUser` not between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("discountproduct.CreateTime is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("discountproduct.CreateTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("discountproduct.CreateTime =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.CreateTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("discountproduct.CreateTime <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.CreateTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("discountproduct.CreateTime >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.CreateTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("discountproduct.CreateTime >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.CreateTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("discountproduct.CreateTime <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.CreateTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("discountproduct.CreateTime <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.CreateTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("discountproduct.CreateTime in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("discountproduct.CreateTime not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("discountproduct.CreateTime between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("discountproduct.CreateTime not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNull() {
            addCriterion("discountproduct.UpdateUser is null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNotNull() {
            addCriterion("discountproduct.UpdateUser is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualTo(String value) {
            addCriterion("discountproduct.UpdateUser =", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.UpdateUser = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualTo(String value) {
            addCriterion("discountproduct.UpdateUser <>", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.UpdateUser <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThan(String value) {
            addCriterion("discountproduct.UpdateUser >", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.UpdateUser > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualTo(String value) {
            addCriterion("discountproduct.UpdateUser >=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.UpdateUser >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThan(String value) {
            addCriterion("discountproduct.UpdateUser <", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.UpdateUser < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualTo(String value) {
            addCriterion("discountproduct.UpdateUser <=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.UpdateUser <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLike(String value) {
            addCriterion("discountproduct.UpdateUser like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotLike(String value) {
            addCriterion("discountproduct.UpdateUser not like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIn(List<String> values) {
            addCriterion("discountproduct.UpdateUser in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotIn(List<String> values) {
            addCriterion("discountproduct.UpdateUser not in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserBetween(String value1, String value2) {
            addCriterion("discountproduct.UpdateUser between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotBetween(String value1, String value2) {
            addCriterion("discountproduct.UpdateUser not between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("discountproduct.UpdateTime is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("discountproduct.UpdateTime is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("discountproduct.UpdateTime =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.UpdateTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("discountproduct.UpdateTime <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.UpdateTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("discountproduct.UpdateTime >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.UpdateTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("discountproduct.UpdateTime >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.UpdateTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("discountproduct.UpdateTime <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.UpdateTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("discountproduct.UpdateTime <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualToColumn(DiscountProductWithBLOBs.Column column) {
            addCriterion(new StringBuilder("discountproduct.UpdateTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("discountproduct.UpdateTime in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("discountproduct.UpdateTime not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("discountproduct.UpdateTime between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("discountproduct.UpdateTime not between", value1, value2, "updateTime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {
        private DiscountProductExample example;

        protected Criteria(DiscountProductExample example) {
            super();
            this.example = example;
        }

        public DiscountProductExample example() {
            return this.example;
        }

        @Deprecated
        public Criteria andIf(boolean ifAdd, ICriteriaAdd add) {
            if (ifAdd) {
                add.add(this);
            }
            return this;
        }

        public Criteria when(boolean condition, ICriteriaWhen then) {
            if (condition) {
                then.criteria(this);
            }
            return this;
        }

        public Criteria when(boolean condition, ICriteriaWhen then, ICriteriaWhen otherwise) {
            if (condition) {
                then.criteria(this);
            } else {
                otherwise.criteria(this);
            }
            return this;
        }

        public Criteria andLogicalDeleted(boolean deleted) {
            return deleted ? andDeletedEqualTo(DiscountProduct.Deleted.IS_DELETED.value()) : andDeletedNotEqualTo(DiscountProduct.Deleted.IS_DELETED.value());
        }

        @Deprecated
        public interface ICriteriaAdd {
            Criteria add(Criteria add);
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }

    public interface ICriteriaWhen {
        void criteria(Criteria criteria);
    }

    public interface IExampleWhen {
        void example(com.ecoolex.discount.sales.entity.DiscountProductExample example);
    }
}